History of db-benchmark timings

Work in progress: performance regression tracking

Note:

• missing LastRun is likely to occur when no runs happened for more than a week, so the values would be the same as LastWeek.
• missing summary values are likely to occur due to the missing timing values, for example, due to the performance regression a question haven’t finished, then we should not skip it during calculating mean. As a result there might be not much to show.
• entries that are constantly missing are removed (like not yet implemented, or pandas 1e9).
• first run timings are used in calculations.
• timing metrics are not normalized when passing to mean, thus mean over data sizes (1e7, 1e8, 1e9) will do something like mean(c(0.1, 1, 10)). As a result mean over time is not matching mean over percent metrics.

Solution

data.table

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	3.5					3.5	-3%	3.3	-5%
2	4.3					3.5	23%	3.5	16%
3	5.4					4.8	11%	4.5	14%
4	6.1					6.1	2%	5.6	10%
5	5.9					5.5	9%	4.9	11%
6	47.2					47.9	-2%
7	128.6					106.7	17%
8	167.6					146.9	11%
9	16.0					14.7	9%	43.9	-46%
10	67.2					68.1	1%	93.7	-12%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	1.1					1.1	6%
1e8	11.1					9.9	9%
1e9	123.3					111.3	8%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	45.2					40.8	8%
1e1
2e0	158.3					141.9	3%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	45.2					40.8	8%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	45.2					40.8	8%
1	43.1					36.2	18%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.1					0.2	-33%	0.2	-32%
1	1e8	1.1					0.9	23%	1.0	12%
1	1e9	9.1					9.3	-2%	8.7	4%
2	1e7	0.1					0.1	7%	0.1	0%
2	1e8	1.3					1.0	40%	1.0	28%
2	1e9	11.5					9.3	23%	9.5	20%
3	1e7	0.2					0.1	26%	0.1	28%
3	1e8	1.4					1.5	-6%	1.5	-8%
3	1e9	14.5					12.8	13%	11.8	22%
4	1e7	0.2					0.2	7%	0.2	21%
4	1e8	1.6					1.5	0%	1.6	-1%
4	1e9	16.4					16.4	0%	14.9	10%
5	1e7	0.2					0.2	23%	0.2	11%
5	1e8	1.4					1.5	-2%	1.5	-1%
5	1e9	16.0					14.9	7%	13.0	22%
6	1e7	1.1					1.2	-5%
6	1e8	11.4					11.6	-1%
6	1e9	129.0					131.0	-1%
7	1e7	3.3					3.0	9%
7	1e8	35.6					28.8	23%
7	1e9	346.8					288.2	20%
8	1e7	3.4					3.1	9%
8	1e8	36.1					32.5	11%
8	1e9	463.2					405.2	14%
9	1e7	1.1					1.0	12%	1.4	-20%
9	1e8	4.3					4.0	6%	9.4	-54%
9	1e9	42.6					39.0	9%	121.0	-64%
10	1e7	1.5					1.5	3%	1.6	-5%
10	1e8	16.6					16.2	2%	16.6	0%
10	1e9	183.4					186.7	-1%	262.8	-30%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	3.5					3.5	-3%	3.3	-5%
1	1e1	5.5					5.1	12%	5.0	15%
1	2e0	5.4					5.5	-5%	6.5	-5%
2	1e2	4.3					3.5	23%	3.5	16%
2	1e1	5.5					4.8	30%	4.2	40%
2	2e0	6.6					5.7	0%	5.9	7%
3	1e2	5.4					4.8	11%	4.5	14%
3	1e1	10.9					9.5	6%	9.3	9%
3	2e0	213.7					213.2	2%
4	1e2	6.1					6.1	2%	5.6	10%
4	1e1	8.6					8.4	-3%	8.5	0%
4	2e0	8.1					7.8	-1%
5	1e2	5.9					5.5	9%	4.9	11%
5	1e1	14.0					10.2	19%	10.1	21%
5	2e0	4.2					3.6	9%	3.7	23%
6	1e2	47.2					47.9	-2%
6	1e1	40.5					39.4	0%
6	2e0	3.0					3.0	7%
7	1e2	128.6					106.7	17%
7	1e1						994.1
7	2e0	703.2					606.6	14%
8	1e2	167.6					146.9	11%
8	1e1	195.1					165.0	17%
8	2e0	826.2					728.6	11%
9	1e2	16.0					14.7	9%	43.9	-46%
9	1e1								27.8
9	2e0	1.6					1.5	8%	2.5	-35%
10	1e2	67.2					68.1	1%	93.7	-12%
10	1e1	15.0					14.0	0%	11.1	20%
10	2e0	10.9					10.8	1%	37.3	-72%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	1.1					1.1	6%
1e2	1e8	11.1					9.9	9%
1e2	1e9	123.3					111.3	8%
1e1	1e7	6.6					5.9	6%
1e1	1e8	71.6					61.7	11%
1e1	1e9
2e0	1e7	28.7					25.8	3%
2e0	1e8	284.8					248.9	3%
2e0	1e9	166.1					164.5	5%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	3.5					3.5	-3%	3.3	-5%
1e2	2	4.3					3.5	23%	3.5	16%
1e2	3	5.4					4.8	11%	4.5	14%
1e2	4	6.1					6.1	2%	5.6	10%
1e2	5	5.9					5.5	9%	4.9	11%
1e2	6	47.2					47.9	-2%
1e2	7	128.6					106.7	17%
1e2	8	167.6					146.9	11%
1e2	9	16.0					14.7	9%	43.9	-46%
1e2	10	67.2					68.1	1%	93.7	-12%
1e1	1	5.5					5.1	12%	5.0	15%
1e1	2	5.5					4.8	30%	4.2	40%
1e1	3	10.9					9.5	6%	9.3	9%
1e1	4	8.6					8.4	-3%	8.5	0%
1e1	5	14.0					10.2	19%	10.1	21%
1e1	6	40.5					39.4	0%
1e1	7						994.1
1e1	8	195.1					165.0	17%
1e1	9								27.8
1e1	10	15.0					14.0	0%	11.1	20%
2e0	1	5.4					5.5	-5%	6.5	-5%
2e0	2	6.6					5.7	0%	5.9	7%
2e0	3	213.7					213.2	2%
2e0	4	8.1					7.8	-1%
2e0	5	4.2					3.6	9%	3.7	23%
2e0	6	3.0					3.0	7%
2e0	7	703.2					606.6	14%
2e0	8	826.2					728.6	11%
2e0	9	1.6					1.5	8%	2.5	-35%
2e0	10	10.9					10.8	1%	37.3	-72%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.1					1.1	6%
0	1e8	11.1					9.9	9%
0	1e9	123.3					111.3	8%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.1					1.1	6%
0	1e8	11.1					9.9	9%
0	1e9	123.3					111.3	8%
1	1e7	1.1					1.0	17%
1	1e8	10.8					8.9	12%
1	1e9	117.3					98.7	26%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	3.2					3.2	5%
2	2.8					2.6	3%
3	5.3					5.2	6%
4	2.9					2.6	21%
5	14.6					14.2	4%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	1.1					1.0	12%
1e8	10.5					10.1	4%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	5.8					5.6	8%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	5.8					5.6	8%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.6					0.5	10%
1	1e8	5.9					5.9	0%
2	1e7	0.5					0.5	0%
2	1e8	5.2					4.8	6%
3	1e7	1.0					0.9	11%
3	1e8	9.6					9.4	1%
4	1e7	0.6					0.4	34%
4	1e8	5.2					4.8	8%
5	1e7	2.7					2.6	5%
5	1e8	26.5					25.8	2%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.1					1.0	12%
0	1e8	10.5					10.1	4%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.1					1.0	12%
0	1e8	10.5					10.1	4%

dplyr

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	14.0	13.8	1%	15.1	-2%	13.9	2%	8.2	74%
2	37.4	38.0	-1%	36.3	1%	37.4	0%	28.6	48%
3	177.8	179.8	-2%	180.0	-2%	178.1	-1%	83.8	105%
4	33.1	32.8	2%	34.0	0%	33.0	3%	30.8	7%
5	192.5	186.4	0%	190.6	-1%	186.6	2%	189.7	0%
6	68.9	73.5	-2%	70.3	-1%	69.4	0%
7	220.5	271.7	-8%	276.5	-9%	216.6	0%
8	496.0	570.5	-5%	575.4	-6%	490.3	0%
9	56.5	57.3	-1%	67.3	-6%	55.7	1%
10	63.7	61.5	3%	63.7	0%	61.7	3%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	8.0	7.8	0%	8.1	-1%	7.8	2%
1e8	29.8	30.4	-1%	30.1	-1%	29.9	0%
1e9	400.6	442.3	-4%	449.9	-6%	395.3	0%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	141.2	154.7	-1%	157.2	-3%	139.5	1%
1e1	139.9	136.8	0%	132.3	0%	136.2	1%
2e0	64.9	64.9	1%	66.4	0%	66.3	0%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	141.2	154.7	-1%	157.2	-3%	139.5	1%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	141.2	154.7	-1%	157.2	-3%	139.5	1%
1	137.2	136.1	0%			136.4	0%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.4	0.4	0%	0.4	3%	0.4	4%	0.2	88%
1	1e8	3.6	3.6	1%	3.7	-2%	3.6	0%	2.2	63%
1	1e9	38.1	37.5	1%	41.3	-7%	37.6	1%	22.2	71%
2	1e7	0.8	0.8	0%	0.8	2%	0.8	3%	0.5	76%
2	1e8	9.3	9.5	-1%	9.5	-2%	9.5	-1%	6.6	40%
2	1e9	102.0	103.6	-1%	98.7	3%	102.0	0%	78.6	29%
3	1e7	1.3	1.5	-7%	1.4	-5%	1.4	-2%	0.7	84%
3	1e8	37.0	36.8	0%	37.0	0%	37.4	-1%	16.8	119%
3	1e9	495.1	501.0	-1%	501.4	-1%	495.4	0%	233.8	111%
4	1e7	0.6	0.6	0%	0.6	0%	0.6	7%	0.6	10%
4	1e8	8.7	8.2	6%	8.5	1%	8.5	2%	8.3	4%
4	1e9	89.9	89.6	0%	92.9	-3%	90.0	0%	83.4	7%
5	1e7	1.5	1.5	-2%	1.6	-7%	1.5	2%	1.5	1%
5	1e8	37.9	38.2	0%	37.6	0%	37.9	0%	39.1	-2%
5	1e9	538.0	519.6	3%	532.6	1%	520.5	3%	528.6	1%
6	1e7	1.7	1.7	2%	1.7	0%	1.7	2%
6	1e8	15.9	16.7	-4%	16.3	-2%	16.0	0%
6	1e9	189.2	202.0	-6%	192.9	-1%	190.6	0%
7	1e7	1.7	1.7	-2%	1.8	-5%	1.7	1%
7	1e8	39.1	39.7	-1%	39.9	-1%	39.7	-1%
7	1e9	620.8	773.7	-19%	787.8	-21%	608.4	2%
8	1e7	6.7	6.7	0%	7.0	-4%	6.7	0%
8	1e8	104.5	108.3	-3%	106.0	-1%	104.6	0%
8	1e9	1376.7	1596.6	-13%	1613.3	-14%	1359.7	1%
9	1e7	1.5	1.4	3%	1.5	0%	1.4	4%
9	1e8	12.2	13.1	-6%	12.5	-1%	12.2	0%
9	1e9	155.9	157.5	0%	188.0	-17%	153.5	1%
10	1e7	63.7	61.5	3%	63.7	0%	61.7	3%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	14.0	13.8	1%	15.1	-2%	13.9	2%	8.2	74%
1	1e1	12.1	12.8	0%	12.8	0%	12.4	3%	5.0	147%
1	2e0	10.9	10.7	3%	10.9	0%	10.8	1%	5.1	146%
2	1e2	37.4	38.0	-1%	36.3	1%	37.4	0%	28.6	48%
2	1e1	24.0	23.2	1%	24.0	0%	24.1	3%	12.9	114%
2	2e0	20.1	20.0	2%	20.6	-3%	20.0	2%	8.0	164%
3	1e2	177.8	179.8	-2%	180.0	-2%	178.1	-1%	83.8	105%
3	1e1	401.8	397.4	0%	395.2	0%	410.8	-1%	171.9	132%
3	2e0	110.1	109.5	3%	110.9	2%	110.6	3%	53.8	149%
4	1e2	33.1	32.8	2%	34.0	0%	33.0	3%	30.8	7%
4	1e1	18.9	18.6	2%	18.7	-1%	19.5	2%	16.2	14%
4	2e0	1.6	1.6	0%	1.6	0%	1.6	1%	1.6	5%
5	1e2	192.5	186.4	0%	190.6	-1%	186.6	2%	189.7	0%
5	1e1	532.5	508.0	1%	475.7	3%	490.3	4%	463.9	-4%
5	2e0	83.8	81.9	0%	86.6	-1%	85.2	1%	110.8	-17%
6	1e2	68.9	73.5	-2%	70.3	-1%	69.4	0%
6	1e1	45.1	45.3	0%	44.8	0%	46.2	0%
6	2e0	4.0	4.0	0%	4.0	-1%	4.0	1%
7	1e2	220.5	271.7	-8%	276.5	-9%	216.6	0%
7	1e1	57.8	58.5	-1%	57.5	0%	57.9	0%
7	2e0	159.3	160.1	0%	165.4	-2%	164.3	-1%
8	1e2	496.0	570.5	-5%	575.4	-6%	490.3	0%
8	1e1	102.4	105.1	-2%	102.2	0%	102.2	0%
8	2e0	236.9	239.3	0%	241.7	-1%	244.1	-2%
9	1e2	56.5	57.3	-1%	67.3	-6%	55.7	1%
9	1e1	4.1	4.1	0%	3.9	1%	3.9	2%
9	2e0	3.2	3.2	0%	3.2	0%	3.3	-2%
10	1e2	63.7	61.5	3%	63.7	0%	61.7	3%
10	1e1	67.0	67.6	0%	66.3	1%	67.2	0%
10	2e0	72.6	72.2	0%	72.4	0%	72.9	0%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	8.0	7.8	0%	8.1	-1%	7.8	2%
1e2	1e8	29.8	30.4	-1%	30.1	-1%	29.9	0%
1e2	1e9	400.6	442.3	-4%	449.9	-6%	395.3	0%
1e1	1e7	10.7	10.8	0%	10.6	0%	10.7	3%
1e1	1e8	53.8	55.0	0%	53.8	1%	53.8	1%
1e1	1e9	484.6	469.4	0%	452.8	1%	469.0	0%
2e0	1e7	17.6	17.4	1%	17.5	0%	17.4	2%
2e0	1e8	122.7	122.9	0%	126.0	0%	126.0	-1%
2e0	1e9	41.8	41.6	0%	42.6	-1%	41.6	0%	17.9	128%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	14.0	13.8	1%	15.1	-2%	13.9	2%	8.2	74%
1e2	2	37.4	38.0	-1%	36.3	1%	37.4	0%	28.6	48%
1e2	3	177.8	179.8	-2%	180.0	-2%	178.1	-1%	83.8	105%
1e2	4	33.1	32.8	2%	34.0	0%	33.0	3%	30.8	7%
1e2	5	192.5	186.4	0%	190.6	-1%	186.6	2%	189.7	0%
1e2	6	68.9	73.5	-2%	70.3	-1%	69.4	0%
1e2	7	220.5	271.7	-8%	276.5	-9%	216.6	0%
1e2	8	496.0	570.5	-5%	575.4	-6%	490.3	0%
1e2	9	56.5	57.3	-1%	67.3	-6%	55.7	1%
1e2	10	63.7	61.5	3%	63.7	0%	61.7	3%
1e1	1	12.1	12.8	0%	12.8	0%	12.4	3%	5.0	147%
1e1	2	24.0	23.2	1%	24.0	0%	24.1	3%	12.9	114%
1e1	3	401.8	397.4	0%	395.2	0%	410.8	-1%	171.9	132%
1e1	4	18.9	18.6	2%	18.7	-1%	19.5	2%	16.2	14%
1e1	5	532.5	508.0	1%	475.7	3%	490.3	4%	463.9	-4%
1e1	6	45.1	45.3	0%	44.8	0%	46.2	0%
1e1	7	57.8	58.5	-1%	57.5	0%	57.9	0%
1e1	8	102.4	105.1	-2%	102.2	0%	102.2	0%
1e1	9	4.1	4.1	0%	3.9	1%	3.9	2%
1e1	10	67.0	67.6	0%	66.3	1%	67.2	0%
2e0	1	10.9	10.7	3%	10.9	0%	10.8	1%	5.1	146%
2e0	2	20.1	20.0	2%	20.6	-3%	20.0	2%	8.0	164%
2e0	3	110.1	109.5	3%	110.9	2%	110.6	3%	53.8	149%
2e0	4	1.6	1.6	0%	1.6	0%	1.6	1%	1.6	5%
2e0	5	83.8	81.9	0%	86.6	-1%	85.2	1%	110.8	-17%
2e0	6	4.0	4.0	0%	4.0	-1%	4.0	1%
2e0	7	159.3	160.1	0%	165.4	-2%	164.3	-1%
2e0	8	236.9	239.3	0%	241.7	-1%	244.1	-2%
2e0	9	3.2	3.2	0%	3.2	0%	3.3	-2%
2e0	10	72.6	72.2	0%	72.4	0%	72.9	0%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	8.0	7.8	0%	8.1	-1%	7.8	2%
0	1e8	29.8	30.4	-1%	30.1	-1%	29.9	0%
0	1e9	400.6	442.3	-4%	449.9	-6%	395.3	0%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	8.0	7.8	0%	8.1	-1%	7.8	2%
0	1e8	29.8	30.4	-1%	30.1	-1%	29.9	0%
0	1e9	400.6	442.3	-4%	449.9	-6%	395.3	0%
1	1e7	6.8	6.8	-3%	6.8	-4%	6.8	-2%
1	1e8	27.8	27.0	3%	27.6	1%	27.1	1%
1	1e9	391.5	389.0	0%			389.7	1%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	11.1	11.4	-2%			11.2	0%
2	8.2	8.3	3%			8.3	-2%
3	8.5	8.5	-2%			8.7	-1%
4	12.8	12.8	-2%			12.9	-2%
5	64.1	63.9	0%			65.2	-3%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	4.2	4.3	0%			4.3	-3%
1e8	37.7	37.7	0%			38.2	-1%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	20.9	21.0	0%			21.3	-2%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	20.9	21.0	0%			21.3	-2%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	6.0	6.1	-1%			6.0	0%
1	1e8	16.2	16.7	-3%			16.3	0%
2	1e7	1.4	1.3	9%			1.5	-4%
2	1e8	14.9	15.3	-2%			15.1	-1%
3	1e7	1.4	1.4	-5%			1.4	-1%
3	1e8	15.7	15.7	0%			16.0	-1%
4	1e7	2.0	2.1	-5%			2.1	-4%
4	1e8	23.6	23.5	0%			23.8	0%
5	1e7	10.1	10.3	-1%			10.7	-5%
5	1e8	118.0	117.4	0%			119.7	-1%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	4.2	4.3	0%			4.3	-3%
0	1e8	37.7	37.7	0%			38.2	-1%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	4.2	4.3	0%			4.3	-3%
0	1e8	37.7	37.7	0%			38.2	-1%

pandas

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1.1	1.2	-1%	1.1	-6%	1.1	0%	1.0	18%
2	4.2	4.1	6%	4.0	0%	3.8	5%	3.3	26%
3	4.4	4.7	-7%	4.4	2%	3.8	0%	4.2	7%
4	3.0	3.1	-6%	2.9	0%	2.9	0%	2.5	15%
5	7.9	7.9	-1%	7.9	1%	7.3	-4%	8.4	-6%
6	8.8	8.7	-3%	8.6	0%	8.6	0%
7	3.7	3.6	1%	3.5	-3%	3.4	-7%
8	28.3	26.1	2%	26.9	3%	25.9	4%
9	29.3	28.6	0%	28.6	2%	29.5	-2%	27.1	11%
10								113.3

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7
1e8

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2
1e1
2e0

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0
1

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.3	0.3	0%	0.3	-20%	0.3	2%	0.2	20%
1	1e8	2.0	2.1	-3%	1.9	7%	2.0	0%	1.7	16%
2	1e7	0.7	0.7	11%	0.8	-6%	0.8	-4%	0.6	24%
2	1e8	7.7	7.6	0%	7.3	5%	6.7	14%	6.0	28%
3	1e7	0.5	0.5	-8%	0.5	4%	0.6	-20%	0.5	10%
3	1e8	8.3	8.8	-5%	8.3	0%	7.0	18%	8.0	4%
4	1e7	0.5	0.6	-8%	0.5	-4%	0.5	0%	0.5	12%
4	1e8	5.4	5.6	-3%	5.3	3%	5.4	1%	4.6	17%
5	1e7	0.9	1.0	-3%	0.9	4%	1.2	-19%	1.0	-5%
5	1e8	14.9	14.8	0%	15.0	-1%	13.5	10%	15.9	-6%
6	1e7	1.5	1.7	-9%	1.6	-1%	1.6	-5%
6	1e8	16.2	15.7	2%	15.6	3%	15.6	3%
7	1e7	0.5	0.5	1%	0.6	-12%	0.7	-25%
7	1e8	6.8	6.7	1%	6.5	4%	6.1	10%
8	1e7	3.6	3.7	-4%	3.5	2%	3.6	0%
8	1e8	53.0	48.5	9%	50.4	5%	48.3	9%
9	1e7	12.8	13.3	-3%	12.6	1%	13.4	-4%	11.0	16%
9	1e8	45.8	43.8	4%	44.6	2%	45.5	0%	43.2	6%
10	1e7								9.7
10	1e8								216.9

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	1.1	1.2	-1%	1.1	-6%	1.1	0%	1.0	18%
1	1e1	1.1	1.1	2%	1.0	4%	1.1	0%	1.0	12%
1	2e0	1.1	1.1	3%	1.1	4%	1.2	-1%	1.0	17%
2	1e2	4.2	4.1	6%	4.0	0%	3.8	5%	3.3	26%
2	1e1	3.2	3.3	-5%	3.5	-3%	2.9	4%	2.6	13%
2	2e0	3.0	3.0	-3%	3.2	-3%	2.8	2%	2.6	15%
3	1e2	4.4	4.7	-7%	4.4	2%	3.8	0%	4.2	7%
3	1e1	8.4	8.6	2%	8.6	0%	8.1	4%	10.8	-24%
3	2e0	14.6	14.7	0%	15.8	-3%	13.4	7%	30.1	-48%
4	1e2	3.0	3.1	-6%	2.9	0%	2.9	0%	2.5	15%
4	1e1	2.9	2.9	1%	2.9	1%	2.9	3%	2.5	16%
4	2e0	2.9	3.0	-3%	2.9	0%	2.9	0%	2.5	13%
5	1e2	7.9	7.9	-1%	7.9	1%	7.3	-4%	8.4	-6%
5	1e1	15.9	16.7	-1%	17.3	-5%	15.8	1%	15.9	-2%
5	2e0	32.6	31.9	2%	33.8	0%	31.7	3%	30.2	7%
6	1e2	8.8	8.7	-3%	8.6	0%	8.6	0%
6	1e1	6.2	6.3	0%	6.3	-1%	6.1	2%
6	2e0	5.6	5.6	2%	5.9	0%	5.5	4%
7	1e2	3.7	3.6	1%	3.5	-3%	3.4	-7%
7	1e1	8.2	8.4	-1%	8.3	-2%	7.8	8%
7	2e0	17.8	17.7	1%	17.9	0%	16.4	8%
8	1e2	28.3	26.1	2%	26.9	3%	25.9	4%
8	1e1	32.8	32.5	1%	33.1	0%	32.9	0%
8	2e0	48.1	48.1	1%	48.8	0%	47.8	0%
9	1e2	29.3	28.6	0%	28.6	2%	29.5	-2%	27.1	11%
9	1e1	15.1	15.2	0%	15.3	1%	15.0	1%	15.3	1%
9	2e0	11.3	11.0	2%	11.2	2%	10.6	4%	11.9	-3%
10	1e2								113.3
10	1e1								67.4
10	2e0								91.9

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7
1e2	1e8
1e1	1e7
1e1	1e8
2e0	1e7
2e0	1e8

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	1.1	1.2	-1%	1.1	-6%	1.1	0%	1.0	18%
1e2	2	4.2	4.1	6%	4.0	0%	3.8	5%	3.3	26%
1e2	3	4.4	4.7	-7%	4.4	2%	3.8	0%	4.2	7%
1e2	4	3.0	3.1	-6%	2.9	0%	2.9	0%	2.5	15%
1e2	5	7.9	7.9	-1%	7.9	1%	7.3	-4%	8.4	-6%
1e2	6	8.8	8.7	-3%	8.6	0%	8.6	0%
1e2	7	3.7	3.6	1%	3.5	-3%	3.4	-7%
1e2	8	28.3	26.1	2%	26.9	3%	25.9	4%
1e2	9	29.3	28.6	0%	28.6	2%	29.5	-2%	27.1	11%
1e2	10								113.3
1e1	1	1.1	1.1	2%	1.0	4%	1.1	0%	1.0	12%
1e1	2	3.2	3.3	-5%	3.5	-3%	2.9	4%	2.6	13%
1e1	3	8.4	8.6	2%	8.6	0%	8.1	4%	10.8	-24%
1e1	4	2.9	2.9	1%	2.9	1%	2.9	3%	2.5	16%
1e1	5	15.9	16.7	-1%	17.3	-5%	15.8	1%	15.9	-2%
1e1	6	6.2	6.3	0%	6.3	-1%	6.1	2%
1e1	7	8.2	8.4	-1%	8.3	-2%	7.8	8%
1e1	8	32.8	32.5	1%	33.1	0%	32.9	0%
1e1	9	15.1	15.2	0%	15.3	1%	15.0	1%	15.3	1%
1e1	10								67.4
2e0	1	1.1	1.1	3%	1.1	4%	1.2	-1%	1.0	17%
2e0	2	3.0	3.0	-3%	3.2	-3%	2.8	2%	2.6	15%
2e0	3	14.6	14.7	0%	15.8	-3%	13.4	7%	30.1	-48%
2e0	4	2.9	3.0	-3%	2.9	0%	2.9	0%	2.5	13%
2e0	5	32.6	31.9	2%	33.8	0%	31.7	3%	30.2	7%
2e0	6	5.6	5.6	2%	5.9	0%	5.5	4%
2e0	7	17.8	17.7	1%	17.9	0%	16.4	8%
2e0	8	48.1	48.1	1%	48.8	0%	47.8	0%
2e0	9	11.3	11.0	2%	11.2	2%	10.6	4%	11.9	-3%
2e0	10								91.9

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7
0	1e8

Sortedness

by Sortedness (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7
0	1e8
1	1e7
1	1e8

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	41.6	45.5	-3%	43.5	0%	46.6	5%
2	68.3	67.2	1%	67.4	0%	62.8	20%
3	37.2	37.7	0%	37.7	-1%	30.3	17%
4	60.2	60.1	0%	59.5	0%	48.1	33%
5	197.0	196.7	0%	194.8	0%	381.8	-52%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	9.9	9.8	1%	9.9	0%	14.7	10%
1e8	151.7	153.1	-1%	151.3	0%	213.2	-1%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	80.8	81.5	0%	80.6	0%	113.9	4%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	80.8	81.5	0%	80.6	0%	113.9	4%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	4.4	4.2	3%	4.3	2%	3.6	22%
1	1e8	78.7	86.9	-9%	82.7	-4%	89.7	-12%
2	1e7	9.6	9.4	2%	9.7	0%	7.2	33%
2	1e8	126.9	125.1	1%	125.1	1%	118.5	7%
3	1e7	5.3	5.3	0%	5.3	0%	4.7	11%
3	1e8	69.0	70.2	-1%	70.0	-1%	55.9	23%
4	1e7	7.9	7.8	1%	7.8	0%	5.6	41%
4	1e8	112.5	112.4	0%	111.1	1%	90.5	24%
5	1e7	22.4	22.4	0%	22.3	0%	52.2	-57%
5	1e8	371.5	371.0	0%	367.4	1%	711.4	-47%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	9.9	9.8	1%	9.9	0%	14.7	10%
0	1e8	151.7	153.1	-1%	151.3	0%	213.2	-1%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	9.9	9.8	1%	9.9	0%	14.7	10%
0	1e8	151.7	153.1	-1%	151.3	0%	213.2	-1%

pydatatable

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	15.7			14.8	-5%	12.9	6%	15.4	-17%
2	19.3			21.0	-4%	20.0	-3%	70.5	-81%
3	43.1			56.4	-21%	49.4	-2%	605.2	-94%
4	41.0			39.1	0%	37.7	1%	17.4	192%
5	9.4			10.1	-10%	9.5	0%	34.6	-67%
6	88.2			103.0	-13%	92.0	0%
7	43.8			50.5	-8%	44.5	0%
8	96.5			109.5	-21%	93.6	0%
9	6.9			7.2	-12%	7.0	-4%
10	229.8			264.4	-8%	232.6	7%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	1.8			2.0	-13%	1.7	0%
1e8	20.1			24.0	-10%	20.2	0%
1e9	156.2			176.8	-7%	157.9	0%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	59.4			67.6	-10%	59.9	0%
1e1	60.0			68.6	-12%	61.0	0%
2e0	77.3			89.8	-6%	79.3	0%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	59.4			67.6	-10%	59.9	0%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	59.4			67.6	-10%	59.9	0%
1	46.4			52.3	-9%	47.2	-1%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.3			0.4	-16%	0.4	-3%	0.5	-31%
1	1e8	3.6			3.9	-6%	3.8	-3%	4.9	-25%
1	1e9	43.0			40.2	7%	34.6	24%	40.8	5%
2	1e7	0.6			0.6	1%	0.7	-8%	6.5	-90%
2	1e8	5.6			6.0	-6%	5.4	4%	33.8	-83%
2	1e9	51.6			56.3	-8%	54.0	-4%	171.3	-69%
3	1e7	1.1			1.5	-28%	1.0	10%	28.6	-96%
3	1e8	10.2			11.4	-10%	10.8	-5%	242.3	-95%
3	1e9	118.0			156.4	-24%	136.4	-13%	1544.8	-92%
4	1e7	0.9			0.9	0%	0.9	-1%	0.3	205%
4	1e8	10.3			11.2	-8%	10.8	-4%	3.0	244%
4	1e9	111.7			105.2	6%	101.5	10%	48.8	128%
5	1e7	0.3			0.3	-18%	0.3	-3%	0.5	-47%
5	1e8	3.7			3.9	-5%	3.5	4%	30.1	-87%
5	1e9	24.3			26.1	-7%	24.7	-1%	73.3	-66%
6	1e7	1.4			1.5	-5%	1.2	11%
6	1e8	65.0			85.2	-23%	68.9	-5%
6	1e9	198.2			222.3	-10%	205.7	-3%
7	1e7	1.1			1.1	-1%	1.1	-1%
7	1e8	10.0			11.1	-10%	9.9	0%
7	1e9	120.4			139.4	-13%	122.5	-1%
8	1e7	2.7			4.4	-37%	3.0	-8%
8	1e8	26.6			31.3	-15%	25.9	2%
8	1e9	260.3			292.9	-11%	251.8	3%
9	1e7	0.2			0.3	-26%	0.2	-12%
9	1e8	1.8			2.0	-6%	1.8	0%
9	1e9	18.7			19.3	-3%	18.9	-1%
10	1e7	9.5			9.5	0%	7.9	20%	608.7	-98%
10	1e8	64.4			74.0	-13%	61.1	5%
10	1e9	615.6			709.5	-13%	628.9	-2%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	15.7			14.8	-5%	12.9	6%	15.4	-17%
1	1e1	6.6			7.7	-11%	7.6	-7%	9.4	-18%
1	2e0	6.4			6.7	-2%	6.6	-3%	7.5	-7%
2	1e2	19.3			21.0	-4%	20.0	-3%	70.5	-81%
2	1e1	19.7			20.2	-9%	19.2	-2%	26.9	-41%
2	2e0	9.9			9.7	3%	8.8	4%	12.0	-28%
3	1e2	43.1			56.4	-21%	49.4	-2%	605.2	-94%
3	1e1	102.4			117.1	-15%	105.5	-3%
3	2e0	197.7			239.6	-12%	198.3	1%
4	1e2	41.0			39.1	0%	37.7	1%	17.4	192%
4	1e1	12.9			14.1	-10%	13.5	-5%
4	2e0	11.6			11.8	-3%	11.9	-4%
5	1e2	9.4			10.1	-10%	9.5	0%	34.6	-67%
5	1e1	50.6			58.0	-11%	53.2	0%
5	2e0	25.5			29.1	-13%	26.4	0%
6	1e2	88.2			103.0	-13%	92.0	0%
6	1e1	29.4			30.8	-5%	29.7	6%
6	2e0	12.4			12.7	-2%	12.1	5%
7	1e2	43.8			50.5	-8%	44.5	0%
7	1e1	98.7			113.8	-13%	98.0	0%
7	2e0	194.7			221.7	-11%	195.9	0%
8	1e2	96.5			109.5	-21%	93.6	0%
8	1e1	48.0			55.9	-23%	49.5	0%
8	2e0	26.9			28.9	-6%	26.5	1%
9	1e2	6.9			7.2	-12%	7.0	-4%
9	1e1	6.2			6.5	-7%	6.6	-2%
9	2e0	5.8			6.0	0%	5.9	1%
10	1e2	229.8			264.4	-8%	232.6	7%
10	1e1	225.3			261.7	-14%	227.6	3%
10	2e0	282.3			331.7	-13%	300.5	-5%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	1.8			2.0	-13%	1.7	0%
1e2	1e8	20.1			24.0	-10%	20.2	0%
1e2	1e9	156.2			176.8	-7%	157.9	0%
1e1	1e7	1.6			1.8	-12%	1.4	3%
1e1	1e8	13.0			15.4	-14%	13.4	-3%
1e1	1e9	165.4			188.5	-9%	168.2	-3%
2e0	1e7	2.0			2.2	-8%	2.0	0%
2e0	1e8	19.2			21.4	-3%	19.5	1%
2e0	1e9	210.8			245.7	-7%	216.4	0%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	15.7			14.8	-5%	12.9	6%	15.4	-17%
1e2	2	19.3			21.0	-4%	20.0	-3%	70.5	-81%
1e2	3	43.1			56.4	-21%	49.4	-2%	605.2	-94%
1e2	4	41.0			39.1	0%	37.7	1%	17.4	192%
1e2	5	9.4			10.1	-10%	9.5	0%	34.6	-67%
1e2	6	88.2			103.0	-13%	92.0	0%
1e2	7	43.8			50.5	-8%	44.5	0%
1e2	8	96.5			109.5	-21%	93.6	0%
1e2	9	6.9			7.2	-12%	7.0	-4%
1e2	10	229.8			264.4	-8%	232.6	7%
1e1	1	6.6			7.7	-11%	7.6	-7%	9.4	-18%
1e1	2	19.7			20.2	-9%	19.2	-2%	26.9	-41%
1e1	3	102.4			117.1	-15%	105.5	-3%
1e1	4	12.9			14.1	-10%	13.5	-5%
1e1	5	50.6			58.0	-11%	53.2	0%
1e1	6	29.4			30.8	-5%	29.7	6%
1e1	7	98.7			113.8	-13%	98.0	0%
1e1	8	48.0			55.9	-23%	49.5	0%
1e1	9	6.2			6.5	-7%	6.6	-2%
1e1	10	225.3			261.7	-14%	227.6	3%
2e0	1	6.4			6.7	-2%	6.6	-3%	7.5	-7%
2e0	2	9.9			9.7	3%	8.8	4%	12.0	-28%
2e0	3	197.7			239.6	-12%	198.3	1%
2e0	4	11.6			11.8	-3%	11.9	-4%
2e0	5	25.5			29.1	-13%	26.4	0%
2e0	6	12.4			12.7	-2%	12.1	5%
2e0	7	194.7			221.7	-11%	195.9	0%
2e0	8	26.9			28.9	-6%	26.5	1%
2e0	9	5.8			6.0	0%	5.9	1%
2e0	10	282.3			331.7	-13%	300.5	-5%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.8			2.0	-13%	1.7	0%
0	1e8	20.1			24.0	-10%	20.2	0%
0	1e9	156.2			176.8	-7%	157.9	0%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.8			2.0	-13%	1.7	0%
0	1e8	20.1			24.0	-10%	20.2	0%
0	1e9	156.2			176.8	-7%	157.9	0%
1	1e7	1.5			1.7	-9%	1.4	-2%
1	1e8	17.5			20.7	-11%	17.6	0%
1	1e9	120.3			134.5	-8%	122.7	0%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	291.3	329.2	2%	13.9	3797%	14.4	3475%
2	314.9	473.1	2%	14.7	4072%	15.6	4013%
3	227.8	291.0	-18%	5.6	3904%	5.7	4510%
4	350.3	451.3	-2%	57.2	2096%	57.3	2136%
5				238.8		261.1

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	14.8	14.3	11%	0.8	4591%	1.5	4624%
1e8	88.7	116.0	-19%	13.4	2159%	10.7	2329%
1e9				183.9		200.3

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0				66.0		70.8

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0				66.0		70.8

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	13.9	11.5	20%	0.2	5958%	0.3	5004%
1	1e8	85.9	85.8	0%	2.4	3550%	2.3	3624%
1	1e9	773.9	890.3	-13%	39.0	1884%	40.8	1799%
2	1e7	22.6	14.1	60%	0.3	7252%	0.3	7181%
2	1e8	99.9	121.8	-17%	3.2	3043%	3.2	3056%
2	1e9	822.1	1283.3	-35%	40.7	1920%	43.2	1801%
3	1e7	7.5	7.2	4%	0.1	5018%	0.1	6693%
3	1e8	34.8	56.3	-38%	1.3	2591%	1.2	2923%
3	1e9	641.1	809.6	-20%	15.2	4104%	16.0	3913%
4	1e7	16.1	13.6	17%	0.4	4360%	0.4	4126%
4	1e8	84.2	84.0	0%	5.4	1456%	4.4	1816%
4	1e9	950.6	1256.3	-24%	166.0	472%	167.2	468%
5	1e7	14.1	25.0	-43%	3.0	368%	6.4	119%
5	1e8	138.9	232.0	-40%	54.7	153%	42.3	228%
5	1e9				658.6		734.5

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	14.8	14.3	11%	0.8	4591%	1.5	4624%
0	1e8	88.7	116.0	-19%	13.4	2159%	10.7	2329%
0	1e9				183.9		200.3

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	14.8	14.3	11%	0.8	4591%	1.5	4624%
0	1e8	88.7	116.0	-19%	13.4	2159%	10.7	2329%
0	1e9				183.9		200.3

spark

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	7.6			10.2	-23%	6.0	30%	7.4	0%
2	9.9			10.1	-11%	9.9	-4%	9.7	4%
3	28.3			27.9	3%	31.3	-5%	186.3	-27%
4	3.5			3.5	2%	3.5	2%	4.0	-13%
5	21.5			21.9	-1%	22.0	-3%	65.0	-23%
7	28.5			25.5	12%	26.5	4%
8	47.4			47.6	-1%	52.3	-3%
9	9.3			9.4	-2%	9.7	-17%	12.8	-11%
10	230.6			249.6	0%	280.2	-3%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	2.0			2.1	-4%	2.2	-7%
1e8	9.1			9.7	-3%	8.6	7%
1e9	117.8			123.4	0%	136.4	0%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	43.0			45.1	-2%	49.1	0%
1e1	47.0			67.7	-4%	45.4	1%
2e0	48.0			61.1	1%	46.9	-1%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	43.0			45.1	-2%	49.1	0%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	43.0			45.1	-2%	49.1	0%
1	46.3			45.5	6%	42.4	8%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	2.1			2.2	-3%	1.7	28%	2.2	-3%
1	1e8	3.0			12.2	-75%	2.2	37%	3.0	0%
1	1e9	17.6			16.4	7%	14.1	24%	16.9	3%
2	1e7	1.5			2.3	-34%	1.7	-12%	1.4	7%
2	1e8	3.7			3.7	0%	3.8	-1%	3.6	3%
2	1e9	24.5			24.4	0%	24.4	0%	24.1	1%
3	1e7	1.7			1.7	-1%	2.0	-14%	1.7	0%
3	1e8	7.0			6.3	10%	6.3	9%	6.7	4%
3	1e9	76.4			75.7	0%	85.5	-10%	550.6	-86%
4	1e7	0.8			0.8	7%	0.7	13%	0.9	-8%
4	1e8	1.2			1.2	0%	1.3	-6%	1.6	-21%
4	1e9	8.6			8.5	0%	8.5	0%	9.5	-10%
5	1e7	1.3			1.4	-4%	1.5	-11%	1.4	-5%
5	1e8	5.0			5.0	0%	4.8	5%	4.8	4%
5	1e9	58.1			59.3	-1%	59.8	-2%	188.8	-69%
7	1e7	1.6			1.5	6%	1.7	-9%
7	1e8	6.8			5.7	18%	5.9	14%
7	1e9	77.1			69.3	11%	71.8	7%
8	1e7	2.5			2.5	-3%	2.5	-3%
8	1e8	10.2			10.3	-1%	9.9	3%
8	1e9	129.6			130.0	0%	144.5	-10%
9	1e7	1.2			1.4	-13%	2.8	-56%	1.4	-10%
9	1e8	3.2			3.0	8%	3.1	2%	3.0	6%
9	1e9	23.4			23.7	-1%	23.2	0%	33.9	-30%
10	1e7	5.2			5.0	3%	5.1	2%	5.2	1%
10	1e8	41.6			40.4	2%	39.8	4%	40.0	3%
10	1e9	645.1			703.5	-8%	795.8	-18%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	7.6			10.2	-23%	6.0	30%	7.4	0%
1	1e1	5.2			5.6	0%	6.0	-17%	6.0	-3%
1	2e0	5.3			5.3	8%	5.6	-12%	6.4	-2%
2	1e2	9.9			10.1	-11%	9.9	-4%	9.7	4%
2	1e1	7.2			8.1	-14%	7.4	-3%	9.4	-6%
2	2e0	5.8			5.5	22%	5.7	7%	5.8	7%
3	1e2	28.3			27.9	3%	31.3	-5%	186.3	-27%
3	1e1	35.1			46.8	-13%	35.9	-2%	174.8	-26%
3	2e0	52.8			61.5	0%	55.6	4%	305.2	-28%
4	1e2	3.5			3.5	2%	3.5	2%	4.0	-13%
4	1e1	3.5			3.2	20%	3.3	18%	3.2	17%
4	2e0	3.2			3.3	2%	3.3	-4%	4.1	-13%
5	1e2	21.5			21.9	-1%	22.0	-3%	65.0	-23%
5	1e1	30.6			40.3	-3%	31.1	0%	65.8	-30%
5	2e0	44.5			51.6	-5%	46.0	-10%	94.5	-17%
7	1e2	28.5			25.5	12%	26.5	4%
7	1e1	33.5			51.0	-16%	33.0	0%
7	2e0	45.6			54.6	-8%	47.5	-8%
8	1e2	47.4			47.6	-1%	52.3	-3%
8	1e1	47.8			56.8	0%	48.4	9%
8	2e0	49.7			53.2	-4%	51.1	0%
9	1e2	9.3			9.4	-2%	9.7	-17%	12.8	-11%
9	1e1	6.5			6.6	0%	6.5	4%	7.0	0%
9	2e0	5.4			5.1	8%	5.2	5%	7.2	-13%
10	1e2	230.6			249.6	0%	280.2	-3%
10	1e1	253.3			391.2	-10%	236.6	6%	467.2	-17%
10	2e0	219.9			309.7	-10%	201.8	5%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	2.0			2.1	-4%	2.2	-7%
1e2	1e8	9.1			9.7	-3%	8.6	7%
1e2	1e9	117.8			123.4	0%	136.4	0%
1e1	1e7	2.2			2.2	4%	2.1	5%
1e1	1e8	10.0			10.1	0%	9.7	1%
1e1	1e9	128.7			190.9	-17%	124.3	-1%
2e0	1e7	2.3			2.2	12%	2.3	0%
2e0	1e8	11.5			11.6	0%	11.7	-4%
2e0	1e9	130.3			169.4	-9%	126.6	0%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	7.6			10.2	-23%	6.0	30%	7.4	0%
1e2	2	9.9			10.1	-11%	9.9	-4%	9.7	4%
1e2	3	28.3			27.9	3%	31.3	-5%	186.3	-27%
1e2	4	3.5			3.5	2%	3.5	2%	4.0	-13%
1e2	5	21.5			21.9	-1%	22.0	-3%	65.0	-23%
1e2	7	28.5			25.5	12%	26.5	4%
1e2	8	47.4			47.6	-1%	52.3	-3%
1e2	9	9.3			9.4	-2%	9.7	-17%	12.8	-11%
1e2	10	230.6			249.6	0%	280.2	-3%
1e1	1	5.2			5.6	0%	6.0	-17%	6.0	-3%
1e1	2	7.2			8.1	-14%	7.4	-3%	9.4	-6%
1e1	3	35.1			46.8	-13%	35.9	-2%	174.8	-26%
1e1	4	3.5			3.2	20%	3.3	18%	3.2	17%
1e1	5	30.6			40.3	-3%	31.1	0%	65.8	-30%
1e1	7	33.5			51.0	-16%	33.0	0%
1e1	8	47.8			56.8	0%	48.4	9%
1e1	9	6.5			6.6	0%	6.5	4%	7.0	0%
1e1	10	253.3			391.2	-10%	236.6	6%	467.2	-17%
2e0	1	5.3			5.3	8%	5.6	-12%	6.4	-2%
2e0	2	5.8			5.5	22%	5.7	7%	5.8	7%
2e0	3	52.8			61.5	0%	55.6	4%	305.2	-28%
2e0	4	3.2			3.3	2%	3.3	-4%	4.1	-13%
2e0	5	44.5			51.6	-5%	46.0	-10%	94.5	-17%
2e0	7	45.6			54.6	-8%	47.5	-8%
2e0	8	49.7			53.2	-4%	51.1	0%
2e0	9	5.4			5.1	8%	5.2	5%	7.2	-13%
2e0	10	219.9			309.7	-10%	201.8	5%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	2.0			2.1	-4%	2.2	-7%
0	1e8	9.1			9.7	-3%	8.6	7%
0	1e9	117.8			123.4	0%	136.4	0%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	2.0			2.1	-4%	2.2	-7%
0	1e8	9.1			9.7	-3%	8.6	7%
0	1e9	117.8			123.4	0%	136.4	0%
1	1e7	2.1			2.2	0%	2.2	-2%
1	1e8	8.9			8.7	21%	8.3	22%
1	1e9	128.0			125.6	-2%	116.7	5%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	267.8			228.7	8%	206.8	13%
2	617.4			630.5	0%	619.1	1%
3	688.3			836.0	-5%	501.2	14%
4				606.4		640.8
5	45.4			45.7	-2%	45.1	2%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	6.1			6.2	1%	5.8	7%
1e8	51.2			51.1	0%	50.8	0%
1e9				1677.5		1427.8

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0				499.7		428.1

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0				499.7		428.1

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	4.7			4.5	6%	4.3	9%
1	1e8	36.9			37.1	0%	37.1	0%
1	1e9	761.8			644.4	18%	578.8	31%
2	1e7	4.2			4.2	0%	4.1	4%
2	1e8	45.8			45.2	1%	45.1	1%
2	1e9	1802.0			1842.0	-2%	1808.2	0%
3	1e7	4.8			4.8	0%	4.6	3%
3	1e8	49.6			49.1	0%	48.8	1%
3	1e9	2010.5			2454.1	-18%	1450.3	38%
4	1e7	5.0			4.8	3%	4.3	14%
4	1e8	44.8			44.8	0%	44.2	1%
4	1e9				1769.6		1873.7
5	1e7	11.9			12.5	-4%	11.4	4%
5	1e8	78.9			78.9	0%	78.9	0%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	6.1			6.2	1%	5.8	7%
0	1e8	51.2			51.1	0%	50.8	0%
0	1e9				1677.5		1427.8

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	6.1			6.2	1%	5.8	7%
0	1e8	51.2			51.1	0%	50.8	0%
0	1e9				1677.5		1427.8

cudf

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	0.0					0.1	-66%
2	0.0					0.1	-40%
3	0.1					1.0	-85%
4	0.1					0.3	-52%
5	0.1					0.1	-10%
6	0.5
10	0.5					0.5	3%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	0.2

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	0.2
1e1	0.2
2e0	0.2

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	0.2

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	0.2
1	0.2

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.0					0.1	-66%
2	1e7	0.0					0.1	-40%
3	1e7	0.1					1.0	-85%
4	1e7	0.1					0.3	-52%
5	1e7	0.1					0.1	-10%
6	1e7	0.5
10	1e7	0.5					0.5	3%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	0.0					0.1	-66%
1	1e1	0.0					0.0	-20%
1	2e0	0.0					0.0	-8%
2	1e2	0.0					0.1	-40%
2	1e1	0.0					0.0	17%
2	2e0	0.0					0.0	19%
3	1e2	0.1					1.0	-85%
3	1e1	0.2					0.1	44%
3	2e0	0.2					0.2	-1%
4	1e2	0.1					0.3	-52%
4	1e1	0.1					0.0	112%
4	2e0	0.1					0.1	55%
5	1e2	0.1					0.1	-10%
5	1e1	0.1					0.1	-8%
5	2e0	0.1					0.1	-6%
6	1e2	0.5
6	1e1	0.4
6	2e0	0.3
10	1e2	0.5					0.5	3%
10	1e1	0.6					0.6	3%
10	2e0	0.6					0.7	-3%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	0.2
1e1	1e7	0.2
2e0	1e7	0.2

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	0.0					0.1	-66%
1e2	2	0.0					0.1	-40%
1e2	3	0.1					1.0	-85%
1e2	4	0.1					0.3	-52%
1e2	5	0.1					0.1	-10%
1e2	6	0.5
1e2	10	0.5					0.5	3%
1e1	1	0.0					0.0	-20%
1e1	2	0.0					0.0	17%
1e1	3	0.2					0.1	44%
1e1	4	0.1					0.0	112%
1e1	5	0.1					0.1	-8%
1e1	6	0.4
1e1	10	0.6					0.6	3%
2e0	1	0.0					0.0	-8%
2e0	2	0.0					0.0	19%
2e0	3	0.2					0.2	-1%
2e0	4	0.1					0.1	55%
2e0	5	0.1					0.1	-6%
2e0	6	0.3
2e0	10	0.6					0.7	-3%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.2

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.2
1	1e7	0.2

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	0.0					2.1	-98%
2	0.0					0.2	-84%
3	0.0					0.8	-94%
4	0.0					0.2	-83%
5	0.2					2.2	-91%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	0.1					1.1	-90%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	0.1					1.1	-90%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	0.1					1.1	-90%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.0					2.1	-98%
2	1e7	0.0					0.2	-84%
3	1e7	0.0					0.8	-94%
4	1e7	0.0					0.2	-83%
5	1e7	0.2					2.2	-91%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.1					1.1	-90%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.1					1.1	-90%

dask

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	247.3			322.8	-8%	321.6	-7%
2	249.6			316.6	-5%	312.5	-4%
3	1862.9			1979.3	-6%	1964.6	-2%
4	1.0			1.0	5%	1.1	-4%	1.0	4%
5	4.0			3.9	-5%	4.1	-9%	3.9	-1%
7	71.3			69.3	12%	71.1	7%
8	2013.4			1894.6	5%	1902.4	5%
9								26.9
10	13.4			13.4	0%	13.9	-4%	13.5	-1%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7
1e8	575.8			544.9	1%	546.2	0%
1e9	2309.6			2565.1	-16%	2549.2	-16%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2
1e1
2e0

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0
1

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.1			0.1	2%	0.1	-2%	0.1	16%
1	1e8	0.7			0.7	-3%	0.7	2%	0.6	9%
1	1e9	741.0			967.4	-23%	964.1	-23%
2	1e7	0.2			0.2	3%	0.2	5%	0.2	20%
2	1e8	1.6			1.5	1%	1.6	0%	1.4	11%
2	1e9	747.0			948.1	-21%	935.8	-20%
3	1e7	1.6			1.7	-5%	1.6	-4%	1.4	12%
3	1e8	146.4			156.4	-6%	144.4	1%	144.1	1%
3	1e9	5440.7			5779.9	-5%	5747.6	-5%
4	1e7	0.2			0.2	9%	0.2	-3%	0.2	15%
4	1e8	1.8			1.7	2%	1.9	-5%	1.9	-5%
5	1e7	0.3			0.4	-18%	0.4	-17%	0.3	-6%
5	1e8	7.8			7.3	6%	7.8	0%	7.5	4%
7	1e7	1.7			1.4	23%	1.4	15%
7	1e8	141.0			137.3	2%	140.8	0%
8	1e7	295.2			280.4	5%	278.7	5%
8	1e8	3731.6			3508.9	6%	3526.0	5%
9	1e7								26.9
10	1e7	13.4			13.4	0%	13.9	-4%	13.5	-1%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	247.3			322.8	-8%	321.6	-7%
1	1e1	263.9			335.6	-3%	341.1	-4%
1	2e0	261.3			329.8	-6%	330.0	-17%
2	1e2	249.6			316.6	-5%	312.5	-4%
2	1e1	264.1			324.1	-5%	326.2	-6%
2	2e0	264.1			326.2	-6%	353.7	-9%
3	1e2	1862.9			1979.3	-6%	1964.6	-2%
3	1e1	268.9			259.9	2%	251.1	1%	236.9	15%
3	2e0	492.5			509.3	0%	577.0	-5%	402.1	45%
4	1e2	1.0			1.0	5%	1.1	-4%	1.0	4%
4	1e1	1.1			1.0	12%	1.1	-8%	0.9	11%
4	2e0	1.0			1.0	0%	1.0	3%	1.0	4%
5	1e2	4.0			3.9	-5%	4.1	-9%	3.9	-1%
5	1e1	14.5			14.6	0%	14.4	0%	14.9	-3%
5	2e0	34.2			33.8	3%	32.7	2%	35.7	-7%
7	1e2	71.3			69.3	12%	71.1	7%
7	1e1	251.6			242.4	2%	248.9	-1%
7	2e0	482.4			491.9	6%	532.0	-3%
8	1e2	2013.4			1894.6	5%	1902.4	5%
8	1e1	2725.9			2461.0	10%	2665.1	2%
9	1e2								26.9
9	1e1								4.0
9	2e0								20.0
10	1e2	13.4			13.4	0%	13.9	-4%	13.5	-1%
10	1e1								24.5
10	2e0								608.9

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7
1e2	1e8	575.8			544.9	1%	546.2	0%
1e2	1e9	2309.6			2565.1	-16%	2549.2	-16%
1e1	1e7
1e1	1e8	173.6			167.6	4%	166.5	3%
1e1	1e9	790.9			988.5	-19%	999.8	-20%
2e0	1e7
2e0	1e8
2e0	1e9	787.2			983.1	-19%	1024.5	-23%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	247.3			322.8	-8%	321.6	-7%
1e2	2	249.6			316.6	-5%	312.5	-4%
1e2	3	1862.9			1979.3	-6%	1964.6	-2%
1e2	4	1.0			1.0	5%	1.1	-4%	1.0	4%
1e2	5	4.0			3.9	-5%	4.1	-9%	3.9	-1%
1e2	7	71.3			69.3	12%	71.1	7%
1e2	8	2013.4			1894.6	5%	1902.4	5%
1e2	9								26.9
1e2	10	13.4			13.4	0%	13.9	-4%	13.5	-1%
1e1	1	263.9			335.6	-3%	341.1	-4%
1e1	2	264.1			324.1	-5%	326.2	-6%
1e1	3	268.9			259.9	2%	251.1	1%	236.9	15%
1e1	4	1.1			1.0	12%	1.1	-8%	0.9	11%
1e1	5	14.5			14.6	0%	14.4	0%	14.9	-3%
1e1	7	251.6			242.4	2%	248.9	-1%
1e1	8	2725.9			2461.0	10%	2665.1	2%
1e1	9								4.0
1e1	10								24.5
2e0	1	261.3			329.8	-6%	330.0	-17%
2e0	2	264.1			326.2	-6%	353.7	-9%
2e0	3	492.5			509.3	0%	577.0	-5%	402.1	45%
2e0	4	1.0			1.0	0%	1.0	3%	1.0	4%
2e0	5	34.2			33.8	3%	32.7	2%	35.7	-7%
2e0	7	482.4			491.9	6%	532.0	-3%
2e0	9								20.0
2e0	10								608.9

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7
0	1e8	575.8			544.9	1%	546.2	0%
0	1e9	2309.6			2565.1	-16%	2549.2	-16%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7
0	1e8	575.8			544.9	1%	546.2	0%
0	1e9	2309.6			2565.1	-16%	2549.2	-16%
1	1e7
1	1e8	564.2			563.9	1%	550.8	-2%
1	1e9	2397.2			2620.5	-15%	2480.4	-13%

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	120.2			111.1	6%	107.6	9%
2	129.2			120.9	2%	113.2	8%
3	122.3			119.5	0%	106.5	9%
4	162.4			135.9	10%	142.9	8%
5	222.8			217.6	2%	219.0	1%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	58.8			57.7	0%	57.6	2%
1e8	249.2			225.9	9%	217.9	14%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	143.4			132.5	4%	128.8	8%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	143.4			132.5	4%	128.8	8%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	17.4			16.6	5%	16.2	7%
1	1e8	222.9			205.6	8%	199.1	11%
2	1e7	17.3			17.7	-2%	17.2	0%
2	1e8	241.0			224.1	7%	209.3	15%
3	1e7	16.0			16.2	-1%	15.5	3%
3	1e8	228.6			222.7	2%	197.6	15%
4	1e7	20.5			20.5	0%	20.2	1%
4	1e8	304.3			251.3	21%	265.6	14%
5	1e7	222.8			217.6	2%	219.0	1%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	58.8			57.7	0%	57.6	2%
0	1e8	249.2			225.9	9%	217.9	14%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	58.8			57.7	0%	57.6	2%
0	1e8	249.2			225.9	9%	217.9	14%

juliadf

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	12.2					14.2	-4%
2	4.9					19.6	-63%
3	56.6					131.9	-56%
4	12.8					18.9	-33%
5	75.8					155.4	-48%
6	67.2					71.3	-2%
7	139.9					141.8	-1%
8	144.1					165.3	-3%
9	80.1					93.6	-14%
10	245.0

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	1.9					2.2	-20%
1e8	12.4					15.5	-25%
1e9	237.3

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	83.9
1e1	10.7					12.8	-19%
2e0	16.9					19.3	-21%

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	83.9

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	83.9
1	72.3

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	6.3					5.8	7%	3.5	77%
1	1e8	6.8					6.9	0%	5.4	25%
1	1e9	23.5					29.8	-21%
2	1e7	0.3					0.6	-42%	0.6	-46%
2	1e8	1.2					4.7	-73%	5.5	-77%
2	1e9	13.3					53.6	-75%
3	1e7	1.1					1.8	-43%	1.2	-14%
3	1e8	4.7					15.2	-68%	16.1	-70%
3	1e9	164.1					378.6	-56%
4	1e7	0.7					1.1	-32%	0.8	-9%
4	1e8	2.8					4.3	-34%	4.2	-32%
4	1e9	34.8					51.4	-32%
5	1e7	0.7					1.2	-41%	1.3	-44%
5	1e8	9.3					19.4	-52%	20.5	-54%
5	1e9	217.4					445.5	-51%
6	1e7	2.4					2.3	4%
6	1e8	14.1					15.0	-5%
6	1e9	185.2					196.5	-5%
7	1e7	1.6					1.6	0%
7	1e8	16.4					16.9	-2%
7	1e9	401.8					407.0	-1%
8	1e7	2.0					2.0	0%
8	1e8	23.8					23.1	3%
8	1e9	406.6					470.7	-13%
9	1e7	1.7					2.2	-21%	2.9	-40%
9	1e8	15.2					16.3	-7%	18.1	-16%
9	1e9	223.3					262.2	-14%
10	1e7	2.2					3.3	-32%	3.6	-37%
10	1e8	29.5					33.7	-12%	37.3	-20%
10	1e9	703.2

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	12.2					14.2	-4%
1	1e1	6.7					6.6	2%	4.7	46%
1	2e0	8.2					8.3	0%	6.3	40%
2	1e2	4.9					19.6	-63%
2	1e1	0.7					1.1	-25%	1.4	-38%
2	2e0	0.8					1.1	-16%	1.6	-33%
3	1e2	56.6					131.9	-56%
3	1e1	9.2					17.9	-51%	19.0	-51%
3	2e0	14.0					26.5	-52%	31.1	-57%
4	1e2	12.8					18.9	-33%
4	1e1	1.9					2.8	-34%	2.6	-24%
4	2e0	2.1					4.0	-44%	3.5	-32%
5	1e2	75.8					155.4	-48%
5	1e1	8.2					16.7	-52%	17.1	-53%
5	2e0	9.9					21.7	-59%	22.3	-60%
6	1e2	67.2					71.3	-2%
6	1e1	6.0					6.1	-3%
6	2e0	7.3					7.9	-10%
7	1e2	139.9					141.8	-1%
7	1e1	17.8					18.6	-4%
7	2e0	29.6					30.9	-9%
8	1e2	144.1					165.3	-3%
8	1e1	28.5					24.1	17%
8	2e0	63.7					52.1	23%
9	1e2	80.1					93.6	-14%
9	1e1	6.0					6.8	-19%	8.6	-39%
9	2e0	6.1					6.8	-18%	10.2	-46%
10	1e2	245.0
10	1e1	21.7					27.7	-26%	28.9	-33%
10	2e0	27.0					33.8	-31%	47.4	-50%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	1.9					2.2	-20%
1e2	1e8	12.4					15.5	-25%
1e2	1e9	237.3
1e1	1e7	2.2					2.6	-20%
1e1	1e8	19.2					23.1	-19%
2e0	1e7	3.1					3.9	-24%
2e0	1e8	30.6					34.7	-19%

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	12.2					14.2	-4%
1e2	2	4.9					19.6	-63%
1e2	3	56.6					131.9	-56%
1e2	4	12.8					18.9	-33%
1e2	5	75.8					155.4	-48%
1e2	6	67.2					71.3	-2%
1e2	7	139.9					141.8	-1%
1e2	8	144.1					165.3	-3%
1e2	9	80.1					93.6	-14%
1e2	10	245.0
1e1	1	6.7					6.6	2%	4.7	46%
1e1	2	0.7					1.1	-25%	1.4	-38%
1e1	3	9.2					17.9	-51%	19.0	-51%
1e1	4	1.9					2.8	-34%	2.6	-24%
1e1	5	8.2					16.7	-52%	17.1	-53%
1e1	6	6.0					6.1	-3%
1e1	7	17.8					18.6	-4%
1e1	8	28.5					24.1	17%
1e1	9	6.0					6.8	-19%	8.6	-39%
1e1	10	21.7					27.7	-26%	28.9	-33%
2e0	1	8.2					8.3	0%	6.3	40%
2e0	2	0.8					1.1	-16%	1.6	-33%
2e0	3	14.0					26.5	-52%	31.1	-57%
2e0	4	2.1					4.0	-44%	3.5	-32%
2e0	5	9.9					21.7	-59%	22.3	-60%
2e0	6	7.3					7.9	-10%
2e0	7	29.6					30.9	-9%
2e0	8	63.7					52.1	23%
2e0	9	6.1					6.8	-18%	10.2	-46%
2e0	10	27.0					33.8	-31%	47.4	-50%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.9					2.2	-20%
0	1e8	12.4					15.5	-25%
0	1e9	237.3

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	1.9					2.2	-20%
0	1e8	12.4					15.5	-25%
0	1e9	237.3
1	1e7	1.8					2.1	-17%
1	1e8	11.9					14.9	-21%
1	1e9	203.3

join

Overview

by Question (no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	168.6					203.2	-33%
2	185.1					218.0	-31%
3	219.9					265.7	-32%
4	189.4					220.6	-30%
5	359.3					434.8	-26%

by Size (no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	14.6					26.9	-46%
1e8	434.3					510.0	-14%

by NA fraction (unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	224.5					268.5	-30%

by Sortedness (no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	224.5					268.5	-30%

Question

by Question Size (no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	12.0					24.7	-51%
1	1e8	325.2					381.8	-14%
2	1e7	10.4					20.7	-49%
2	1e8	359.8					415.2	-13%
3	1e7	15.4					30.4	-49%
3	1e8	424.5					501.0	-15%
4	1e7	10.5					20.1	-47%
4	1e8	368.2					421.1	-12%
5	1e7	24.5					38.5	-36%
5	1e8	694.0					831.1	-16%

NA fraction

by NA fraction Size (unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	14.6					26.9	-46%
0	1e8	434.3					510.0	-14%

Sortedness

by Sortedness Size (no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	14.6					26.9	-46%
0	1e8	434.3					510.0	-14%

clickhouse

groupby

Overview

by Question (k=1e2, no NA, unsorted)

Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	85.1					31.1	45%	15.4	173%
2	3.4					10.9	-30%	7.4	-16%
3	7.2					36.8	-11%	33.4	-29%
4	17.2					22.8	-8%	20.2	-16%
5	10.9					14.3	-12%	13.6	-19%
6	15.6					12.8	37%
7	19.0					15.2	53%
8	44.4					42.8	2%
9	37.0					17.5	52%
10	9.3					9.8	-3%

by Size (k=1e2, no NA, unsorted)

Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e7	0.4					0.4	33%
1e8	3.1					3.4	-9%
1e9	78.1					66.1	15%

by K cardinality (no NA, unsorted)

K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	25.5					21.8	13%
1e1	25.9					17.4	76%
2e0	23.5

by NA fraction (k=1e2, unsorted)

NA fraction	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	25.5					21.8	13%

by Sortedness (k=1e2, no NA)

Sorted	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	25.5					21.8	13%
1	8.1					9.0	-11%

Question

by Question Size (k=1e2, no NA, unsorted)

Q	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e7	0.1					0.2	-32%	0.1	93%
1	1e8	0.3					0.3	-5%	0.4	-28%
1	1e9	254.9					92.7	174%	45.8	457%
2	1e7	0.1					0.1	-9%	0.1	5%
2	1e8	0.9					1.1	-11%	0.9	1%
2	1e9	9.0					31.6	-71%	21.1	-57%
3	1e7	0.2					0.1	65%	0.2	30%
3	1e8	1.1					1.4	-18%	1.8	-39%
3	1e9	20.3					109.0	-81%	98.1	-79%
4	1e7	0.0					0.0	-4%	0.0	-15%
4	1e8	0.3					0.2	3%	0.3	-18%
4	1e9	51.2					68.0	-24%	60.2	-15%
5	1e7	0.1					0.1	-7%	0.1	-7%
5	1e8	1.1					1.1	-4%	1.5	-31%
5	1e9	31.7					41.7	-24%	39.2	-19%
6	1e7	0.5					0.2	131%
6	1e8	1.1					1.9	-42%
6	1e9	45.4					36.4	24%
7	1e7	0.4					0.2	138%
7	1e8	1.1					1.2	-3%
7	1e9	55.5					44.1	25%
8	1e7	0.9					0.8	13%
8	1e8	6.9					7.6	-9%
8	1e9	125.4					119.9	4%
9	1e7	0.2					0.2	42%
9	1e8	1.0					1.0	0%
9	1e9	109.8					51.3	114%
10	1e7	1.7					1.8	-1%
10	1e8	16.9					17.8	-5%

by Question K cardinality (no NA, unsorted)

Q	K	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1	1e2	85.1					31.1	45%	15.4	173%
1	1e1	14.9					0.8	658%	40.7	-30%
1	2e0	10.5					0.8	483%
2	1e2	3.4					10.9	-30%	7.4	-16%
2	1e1	9.1					4.1	10%	7.1	-24%
2	2e0	4.3					4.2	-34%
3	1e2	7.2					36.8	-11%	33.4	-29%
3	1e1	83.0					26.4	71%	47.2	15%
3	2e0	69.3					40.7	21%
4	1e2	17.2					22.8	-8%	20.2	-16%
4	1e1	24.5					15.5	23%	18.6	4%
4	2e0	23.1					20.5	-21%
5	1e2	10.9					14.3	-12%	13.6	-19%
5	1e1	15.6					18.8	-17%	19.3	-13%
5	2e0	21.9					26.3	-7%
6	1e2	15.6					12.8	37%
6	1e1	14.4					9.6	2%
6	2e0	5.7					8.7	-41%
7	1e2	19.0					15.2	53%
7	1e1	25.9					19.9	5%
7	2e0	34.4					26.2	10%
8	1e2	44.4					42.8	2%
8	1e1	31.3					38.3	-10%
8	2e0	33.3
9	1e2	37.0					17.5	52%
9	1e1	25.2					28.3	0%
9	2e0	18.5
10	1e2	9.3					9.8	-3%
10	1e1	9.0					9.9	-11%
10	2e0	9.3					9.3	-10%

K cardinality

by K cardinality Size (no NA, unsorted)

K	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1e7	0.4					0.4	33%
1e2	1e8	3.1					3.4	-9%
1e2	1e9	78.1					66.1	15%
1e1	1e7	0.3					0.4	-15%
1e1	1e8	3.2					3.5	-9%
1e1	1e9	79.4					51.8	272%
2e0	1e7	0.4					0.5	-21%
2e0	1e8	4.2					4.5	-23%
2e0	1e9	70.6

by K cardinality Question (no NA, unsorted)

K	Q	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
1e2	1	85.1					31.1	45%	15.4	173%
1e2	2	3.4					10.9	-30%	7.4	-16%
1e2	3	7.2					36.8	-11%	33.4	-29%
1e2	4	17.2					22.8	-8%	20.2	-16%
1e2	5	10.9					14.3	-12%	13.6	-19%
1e2	6	15.6					12.8	37%
1e2	7	19.0					15.2	53%
1e2	8	44.4					42.8	2%
1e2	9	37.0					17.5	52%
1e2	10	9.3					9.8	-3%
1e1	1	14.9					0.8	658%	40.7	-30%
1e1	2	9.1					4.1	10%	7.1	-24%
1e1	3	83.0					26.4	71%	47.2	15%
1e1	4	24.5					15.5	23%	18.6	4%
1e1	5	15.6					18.8	-17%	19.3	-13%
1e1	6	14.4					9.6	2%
1e1	7	25.9					19.9	5%
1e1	8	31.3					38.3	-10%
1e1	9	25.2					28.3	0%
1e1	10	9.0					9.9	-11%
2e0	1	10.5					0.8	483%
2e0	2	4.3					4.2	-34%
2e0	3	69.3					40.7	21%
2e0	4	23.1					20.5	-21%
2e0	5	21.9					26.3	-7%
2e0	6	5.7					8.7	-41%
2e0	7	34.4					26.2	10%
2e0	8	33.3
2e0	9	18.5
2e0	10	9.3					9.3	-10%

NA fraction

by NA fraction Size (k=1e2, unsorted)

NA fraction	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.4					0.4	33%
0	1e8	3.1					3.4	-9%
0	1e9	78.1					66.1	15%

Sortedness

by Sortedness Size (k=1e2, no NA)

Sorted	Size	Now	LastRun	LR ∆	LastWeek	LW ∆	LastMonth	LM ∆	LastYear	LY ∆
0	1e7	0.4					0.4	33%
0	1e8	3.1					3.4	-9%
0	1e9	78.1					66.1	15%
1	1e7	0.3					0.3	-7%
1	1e8	2.9					3.2	-12%
1	1e9	22.4					24.9	-14%

join

join for clickhouse not yet implemented.

Details

Environment

Nodename: mr-dl11

Timings

---

Report was generated on: 2020-05-15 11:12:38 PDT.